﻿CREATE PROCEDURE dbo.SP_MemberJobs_UPDATE
												@EmployedFrom DateTime 							  =  NULL 
														, @EmployedTo DateTime 							  =  NULL 
														, @Employeer NVarChar 							(50)  =  NULL 
														, @IsCurrentJob Bit 							  =  NULL 
														, @JobId Int 							  =  NULL 
														, @MemberId Int 							  =  NULL 
														, @Position NVarChar 							(50)  =  NULL 
												AS
					UPDATE MemberJobs SET
													EmployedFrom=@EmployedFrom 
																,EmployedTo=@EmployedTo
																,Employeer=@Employeer
																,IsCurrentJob=@IsCurrentJob
																,MemberId=@MemberId
																,Position=@Position
													Where 	
												JobId=@JobId
							